Stock market reports from Youtube | Stock market reports on Twitter

Finance in Excel 2 - Import and Chart Historical Stock Prices in Excel Video

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

Learn how to Import and quickly Chart historical stock prices in Microsoft Excel using data from Yahoo Finance. This is a great way to visualize the moves in a particular stock. This tutorial also shows you how to import data from the web and to quickly graph and chart information in Excel 2007.

For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Comments on "Finance in Excel 2 - Import and Chart Historical Stock Prices in Excel"

@ExcelisHell Is ...
@ExcelisHell Is there a way to get excel to make 1? day, 1 week, etc. charts using current data and then storing that data? Would there be a way to get moving averages, etc. from that?

great help ?
great help ?

thanks a lot for ...
thanks a lot for this video !! great job? !!

in excel 2003, the ...
in excel 2003, the data is charted from most recent to earliest, the opposite of how it should be.? 2007/2011 seems to recognize how time passes and adjust accordingly, regardless of how the data is arranged in the spreadsheet. Because of this, I have to flip the data in Excel 2003. Do you know of a way to avoid this?

Good video?
Good video?

Should this work in ...
Should this work in Excel 2011 for Mac? There does not seem to be get data 'From Web'? option on the Data ribbon - only 'HTML'.

do it in parts? or ...
do it in parts? or copy by hand.

How can you import ...
How can you import multiple year of data into excel using this method? Since the data is too long, you have? to click on next page to see historical data from a different period. But once you go to the next page, the previously checked green arrow is no longer recognized.